* Take list of doctors on the open letter and calculate number of doctors and general practitioners by municipality
import excel "$raw/vaccine_skeptic_doctors.xlsx", sheet("Sheet1") firstrow clear

lab var gp "General practitioner"

gen any = 1

collapse (count) gp any, by(municipality_id)

drop if municipality_id==. // drops two cases of non-practicing doctors

rename gp antivax_gps
rename any antivax_docs

lab var antivax_gps "Vaccine-sceptic GPs"
lab var antivax_docs "Vaccine-sceptic doctors"

save "$edited/vaccine_skeptic_doctors.dta", replace
